'Usage Dim instance As CalcMatchFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
Parameters
- args
The args contains 2 - 3 items: lookup_value, lookup_array, [match_type].
Lookup_value is the value you use to find the value you want in a table.
Lookup_array is a contiguous range of cells containing possible lookup values. Lookup_array must be an array or an array reference.
[Match_type] is the number -1, 0, or 1. Match_type specifies how to matches lookup_value with values in lookup_array.